-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllTrees`(IN p_userId BIGINT)
BEGIN

SELECT `userId`,`fullName` FROM users WHERE `userId` != p_userId;

END
